Proposal of an inventory control system based on the flow of materials in a warehouse using Excel/VBA

Inventory management systems are indispensable for most companies since the cost of implementing robust systems, such as Warehouse Management System (WMS), leads to invest a high implementation value depending on structure that best suits their internal flow. Thus, this article sought present more viable software material in one warehouses an assembler two-wheeler hub Manaus, where no warehouse system controls flow materials and addressing. The Excel program developed using programming language linked Microsoft Office: Visual Basic Applications (VBA). This presented itself alternative with than WMS. In addition, system’s functioning was based process already done stock, facilitating its acceptance by operators